
import pandas as pd
import plotly.express as px


df = pd.read_csv("netflix_titles.csv")
df.head()


df.dtypes

show_id         object
type            object
title           object
director        object
cast            object
country         object
date_added      object
release_year     int64
rating          object
duration        object
listed_in       object
description     object
dtype: object


df["date_added"] = pd.to_datetime(df["date_added"])


df.describe()


px.histogram(df, x = "release_year")


px.histogram(df, x = "date_added")


df["date_added_month"] = df["date_added"].dt.month


px.histogram(df, x="date_added_month")


df["date_added_day"] = df["date_added"].dt.day
px.histogram(df, x="date_added_day")


df["type"].value_counts()

Movie      6131
TV Show    2676
Name: type, dtype: int64


px.histogram(df, x="date_added_day",color="type")


df["country"].dropna().unique()[:10]

array(['United States', 'South Africa', 'India',
       'United States, Ghana, Burkina Faso, United Kingdom, Germany, Ethiopia',
       'United Kingdom', 'Germany, Czech Republic', 'Mexico', 'Turkey',
       'Australia', 'United States, India, France'], dtype=object)


df.columns

Index(['show_id', 'type', 'title', 'director', 'cast', 'country', 'date_added',
       'release_year', 'rating', 'duration', 'listed_in', 'description',
       'date_added_month', 'date_added_day'],
      dtype='object')


df[["title", "country"]].head(10)


df["country"].str.split(",", expand=True).head(10)


country = df.copy()
country = pd.concat([country,df["country"].str.split(",", expand=True)],axis=1)
pd.set_option('display.max_columns', None)
country.head(10)


# lets change it from wide to long format
country = pd.melt(country, id_vars=['type','title'], value_vars=range(12))
country


# withount NA values
country = country[country["value"].notna()]


px.histogram(country, x="value")


country["value"] = country["value"].str.strip()

C:\Users\Thinkpad\AppData\Local\Temp\ipykernel_812\3566639422.py:1: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy


px.histogram(country, x="value",color="type")


# lets include the type and sort it in descending order
px.histogram(country, x="value", color="type").update_xaxes(categoryorder="total descending")


country[country["value"] == "Egypt"]


# for example this one "Black Crows"
df[df["title"] == "Black Crows"]


genre = df.copy()
genre = pd.concat([genre, df["listed_in"].str.split(",", expand=True)], axis=1)
genre


genre = pd.melt(genre, id_vars=["type","title"], value_vars=range(3))
genre = genre[genre["value"].notna()]
genre


genre["value"] = genre["value"].str.strip()


px.histogram(genre, x="value", color="type").update_xaxes(categoryorder="total descending")

	show_id	type	title	director	cast	country	date_added	release_year	rating	duration	listed_in	description
0	s1	Movie	Dick Johnson Is Dead	Kirsten Johnson	NaN	United States	September 25, 2021	2020	PG-13	90 min	Documentaries	As her father nears the end of his life, filmm...
1	s2	TV Show	Blood & Water	NaN	Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban...	South Africa	September 24, 2021	2021	TV-MA	2 Seasons	International TV Shows, TV Dramas, TV Mysteries	After crossing paths at a party, a Cape Town t...
2	s3	TV Show	Ganglands	Julien Leclercq	Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi...	NaN	September 24, 2021	2021	TV-MA	1 Season	Crime TV Shows, International TV Shows, TV Act...	To protect his family from a powerful drug lor...
3	s4	TV Show	Jailbirds New Orleans	NaN	NaN	NaN	September 24, 2021	2021	TV-MA	1 Season	Docuseries, Reality TV	Feuds, flirtations and toilet talk go down amo...
4	s5	TV Show	Kota Factory	NaN	Mayur More, Jitendra Kumar, Ranjan Raj, Alam K...	India	September 24, 2021	2021	TV-MA	2 Seasons	International TV Shows, Romantic TV Shows, TV ...	In a city of coaching centers known to train I...

	release_year
count	8807.000000
mean	2014.180198
std	8.819312
min	1925.000000
25%	2013.000000
50%	2017.000000
75%	2019.000000
max	2021.000000

	title	country
0	Dick Johnson Is Dead	United States
1	Blood & Water	South Africa
2	Ganglands	NaN
3	Jailbirds New Orleans	NaN
4	Kota Factory	India
5	Midnight Mass	NaN
6	My Little Pony: A New Generation	NaN
7	Sankofa	United States, Ghana, Burkina Faso, United Kin...
8	The Great British Baking Show	United Kingdom
9	The Starling	United States

	show_id	type	title	director	cast	country	date_added	release_year	rating	duration	listed_in	description	date_added_month	date_added_day	0	1	2	3	4	5	6	7	8	9	10	11
0	s1	Movie	Dick Johnson Is Dead	Kirsten Johnson	NaN	United States	2021-09-25	2020	PG-13	90 min	Documentaries	As her father nears the end of his life, filmm...	9.0	25.0	United States	None	None	None	None	None	None	None	None	None	None	None
1	s2	TV Show	Blood & Water	NaN	Ama Qamata, Khosi Ngema, Gail Mabalane, Thaban...	South Africa	2021-09-24	2021	TV-MA	2 Seasons	International TV Shows, TV Dramas, TV Mysteries	After crossing paths at a party, a Cape Town t...	9.0	24.0	South Africa	None	None	None	None	None	None	None	None	None	None	None
2	s3	TV Show	Ganglands	Julien Leclercq	Sami Bouajila, Tracy Gotoas, Samuel Jouy, Nabi...	NaN	2021-09-24	2021	TV-MA	1 Season	Crime TV Shows, International TV Shows, TV Act...	To protect his family from a powerful drug lor...	9.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	s4	TV Show	Jailbirds New Orleans	NaN	NaN	NaN	2021-09-24	2021	TV-MA	1 Season	Docuseries, Reality TV	Feuds, flirtations and toilet talk go down amo...	9.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	s5	TV Show	Kota Factory	NaN	Mayur More, Jitendra Kumar, Ranjan Raj, Alam K...	India	2021-09-24	2021	TV-MA	2 Seasons	International TV Shows, Romantic TV Shows, TV ...	In a city of coaching centers known to train I...	9.0	24.0	India	None	None	None	None	None	None	None	None	None	None	None
5	s6	TV Show	Midnight Mass	Mike Flanagan	Kate Siegel, Zach Gilford, Hamish Linklater, H...	NaN	2021-09-24	2021	TV-MA	1 Season	TV Dramas, TV Horror, TV Mysteries	The arrival of a charismatic young priest brin...	9.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	s7	Movie	My Little Pony: A New Generation	Robert Cullen, José Luis Ucha	Vanessa Hudgens, Kimiko Glenn, James Marsden, ...	NaN	2021-09-24	2021	PG	91 min	Children & Family Movies	Equestria's divided. But a bright-eyed hero be...	9.0	24.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	s8	Movie	Sankofa	Haile Gerima	Kofi Ghanaba, Oyafunmike Ogunlano, Alexandra D...	United States, Ghana, Burkina Faso, United Kin...	2021-09-24	1993	TV-MA	125 min	Dramas, Independent Movies, International Movies	On a photo shoot in Ghana, an American model s...	9.0	24.0	United States	Ghana	Burkina Faso	United Kingdom	Germany	Ethiopia	None	None	None	None	None	None
8	s9	TV Show	The Great British Baking Show	Andy Devonshire	Mel Giedroyc, Sue Perkins, Mary Berry, Paul Ho...	United Kingdom	2021-09-24	2021	TV-14	9 Seasons	British TV Shows, Reality TV	A talented batch of amateur bakers face off in...	9.0	24.0	United Kingdom	None	None	None	None	None	None	None	None	None	None	None
9	s10	Movie	The Starling	Theodore Melfi	Melissa McCarthy, Chris O'Dowd, Kevin Kline, T...	United States	2021-09-24	2021	PG-13	104 min	Comedies, Dramas	A woman adjusting to life after a loss contend...	9.0	24.0	United States	None	None	None	None	None	None	None	None	None	None	None

	type	title	variable	value
0	Movie	Dick Johnson Is Dead	0	United States
1	TV Show	Blood & Water	0	South Africa
2	TV Show	Ganglands	0	NaN
3	TV Show	Jailbirds New Orleans	0	NaN
4	TV Show	Kota Factory	0	India
...	...	...	...	...
105679	Movie	Zodiac	11	None
105680	TV Show	Zombie Dumb	11	NaN
105681	Movie	Zombieland	11	None
105682	Movie	Zoom	11	None
105683	Movie	Zubaan	11	None

Netfkix EDA¶

Dataset available at :https://www.kaggle.com/datasets/shivamb/netflix-shows¶

Import Data¶

High Level EDA¶

Change "date_added" to datetime¶

Numerical Columns Describe¶

Look at release year distribution¶

It shows us that most movies in Netflix are quite recently relaease (2010:2020)¶

A lot have been released at 2018¶

I really cab't see any pattern here. Let's look at the month they add movies in¶

Again no clear pattern here, what about the day¶

Finally we got somthing interesting. They tend to add movies on the fitst day each month often more other days¶

Nowadays, I am watching Stranger Things and they added a volume on 1st June, another one on 1st July so that it could be somthing true¶

String Columns Analysis¶

Type (Movie, TV Series)¶

It seems like Netflix has Movies more then TV Series¶

Is that absolutely true or it depends on for example the country movies made in¶

Let's look at the proportion (Movies & TV series) by countries¶

Intersting thing that some movies have multiple countries. Let's try to get how many movies made in each country¶

United States is showing twice beacause there is a space, we can trim it¶

As expected, the US has the most movies.¶

India has mora than the UK but the UK produces a significantly higher proportion of TV series relative to its total number.¶

Of course, South Korea produces a lot more of TV series than movies¶

It's kind of interesting to see "Egypt", my country, at the top 10, let's see those movies & TV series¶

A lot of those things I am not familier of and never heard of, I think most of them are made in Egypt and other countries as well¶

We can do the same for "Listed in" column or genre¶

I think we can't get much out of it as we can see we have a categories called "Movies, TV Shows,..."¶

	type	title	variable	value
457	Movie	Lift Like a Girl	0	Egypt
529	Movie	Return of the Prodigal Son	0	Egypt
859	Movie	Asmaa	0	Egypt
991	Movie	One Like It	0	Egypt
1137	Movie	The Knight and the Princess	0	Egypt
...	...	...	...	...
11161	Movie	Destiny	1	Egypt
11173	Movie	Alexandria: Again and Forever	1	Egypt
11267	Movie	The Other	1	Egypt
14742	Movie	The Square	1	Egypt
22517	TV Show	Black Crows	2	Egypt